package com.three.mapper;

import com.three.entity.Goods;
import com.three.vo.*;
import org.apache.ibatis.annotations.MapKey;

import java.util.List;
import java.util.Map;

/**
 * @author 曹梦1
 * @description 针对表【goods】的数据库操作Mapper
 * @createDate 2024-10-24 09:21:19
 * @Entity com.three.entity.Goods
 */
public interface GoodsMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(Goods record);

    int insertSelective(Goods record);

    Goods selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Goods record);

    int updateByPrimaryKey(Goods record);

    @MapKey("id")
    List<Map<String, Object>> selectgoods(KeyboardVO keyboardVO);

    // 查询商品 盘点商品页面
    @MapKey("id")
    List<Map<String, Object>> selectgoodsyuan(KeyboardVO keyboardVO);


    @MapKey("id")
    List<Map<String, Object>> getAllOutGoods(AddOutLibrartVo addOutLibrartVo);

    //点击新增入库按钮展示所有
    @MapKey("id")
    List<Map<String, Object>> selectGoodsAll(Integer branchid);

    //点击新增商品按钮展示所有
    @MapKey("id")
    List<Map<String, Object>> selectList();


    String getByGoodsName(Integer abc);

    int addgoods(AddintLibraryVO goods1);

    @MapKey("id")
    List<Map<String, Object>> selectbybranchid(Integer branchid);
    // 查询商品,得到商品数目，商品进价，商品售价，商品利润
    List<GoodsNumJinShouVo> selectGoodsShuJinSou(Integer branchid);

    List<Goods> getAllNameJingShou();

    Goods selectBygoodsid(Integer goodsid);

}

